Dashboard 03 - Creating Matrix, Map, & Line and Stacked Column chart Visualizations - Part 01 20
In this step, we will create a matrix, map and chart in the 3rd dashboard.
Step 1 - Create a Block Address Matrix
In Power BI Desktop, click on the page, RaleighPoliceIncidents-Street
Visualizations
Click the Matrix icon
Fields
Select the following:
A_KeyMeasures -> .Total_Case_Numbers - Under Visualizations, drag & drop it in the Values section
A_KeyMeasures -> .Total_Shooting_Crimes - Under Visualizations, drag & drop it in the Values section
Raleigh_Police_Incidents_NIBRS -> Crime_Description - Under Visualizations, drag & drop it in the Rows section
Raleigh_Police_Incidents_NIBRS -> MonthFull - Under Visualizations, drag & drop it in the Rows section
Raleigh_Police_Incidents_NIBRS -> Reported_Block_Address - Under Visualizations, drag & drop it in the Rows section
Raleigh_Police_Incidents_NIBRS -> reported_Date_Hierarchy -> Reported_Date - Under Visualizations, drag & drop it in the Rows section
Raleigh_Police_Incidents_NIBRS -> reported_Date_Hierarchy -> Reported_Year - Under Visualizations, drag & drop it in the Rows section
Raleigh_Police_Incidents_NIBRS -> reported_dayofwk - Under Visualizations, drag & drop it in the Rows sectionVisualizations
Fields tab
Under Fields tab, click on the down arrow -> Rename for this visual and rename the fields as follows:
.Total_Case_Numbers = Total Police Incidents
.Total_Shooting_Crimes = Total Shootings
Crime_Description = Crime Description
Reported_Block_Address = Reported Block Address
reported_dayofwk = Reported Day of the Week
Visualization Listing should look as follows, in the following order:
Under Format -> General: X Position = 0 , Y Position = 156 , Width = 605 , Height = 496
Under Format -> Grid -> Outline Color = 094780 , Outline Weight = 1 , Text Size = 12 pt , Image Height = 75
Under Format -> Column Headers -> Font Color = 094780 , Background Color = E6E6E6 , Outline = Bottom Only , Font Family = 13 pt , Title Alignment = Center
Under Format -> Row Headers -> Font Color = 000000 , Background Color = FFFFFF , Stepped Layout = ON , Font Family = 12 pt , Icon Size = 12 pt
Under Format -> Subtotals -> Set it to ON -> Font Color = 000000 , Font Family = Segoe UI , Background Color = FFFFFF , Text Size = 13 pt , Row Subtotal Position = Top
Under Format -> Grand Total -> Set it to ON -> Font Color = 000000 , Font Family = Segoe UI , Background Color = FFFFFF , Text Size = 13 pt
Under Format -> Conditional Formatting -> Background Color = OFF , Font Color = ON , Advanced Controls , Format by = Rules , Apply to = Values Only , Based on Field = .Total_Case_Numbers , Rules:
If Value is greater than or equal to 0 Number and is less then 50 Number then Color = 008000
If Value is greater than or equal to 51 Number and is less then 100 Number then Color = A0D1FF
If Value is greater than or equal to 101 Number and is less then 250 Number then Color = E68F96
If Value is greater than or equal to 251 Number and is less then 500 Number then Color = DE6A73
If Value is greater than or equal to 501 Number and is less then 999999 Number then Color = FF0000
Under Format -> Title -> Set it to OFF
Under Format -> Background -> Set it to ON , Color = FFF
Under Format -> Border -> Set it to ON , Color = 666666
Filters
NoneWhen finished, save project.